﻿using System;
using System.Collections.Generic;
using System.Text;

using System.Data;

namespace DBWorker
{
    interface IDBWorker : IDBWorkerBase
    {
        DataTable GetDataTableByCommand(string query);

        DataTable GetDataTableByTableName(string tableName);

        DataRow GetDataRowByCommand(string query);

        object GetObjectByCommand(string query);

        DataTable GetDataTableSchema(string query);

        void ExecuteScalar(string query);

        void UpdateDataTable(DataTable dataTable, string tableName);

        void UpdateDataTable(DataRow[] dataRow, string tableName);

        int GetLastInsertedIDByTableName(string tableName);

        Guid GetLastInsertedGuidByTableName(string tableName);

        DataTable GetDatabaseTablesInfo();

        DataTable GetDatabaseInfo();

        DataTable GetTableInfoByTableName(string tableName);

    }
}
